Quantile remap example

A Quantile remap is similar to a Numeric remap in that you can create ranges on a numeric field.

You choose the number of bands (or quantiles) that you require and iLoader populates each band with the same number of records (for example, four bands each containing 500,000 records).

The script is written in the following format:

If you are using the Data Transformation wizard, these entries relate to the column fields as follows:

The following example creates a new field called Income Quantile, containing 4 dimensions, from the Income column of the Customer table.

• Data Transformation Examples
  • Decode Remap Examples
  • Numeric Remap Example
  • Functions Remap Example
  • Parametric Remap Example
  • Quantile Remap Example
  • Expression Based Dynamic Fields Example
  • Aggregate Based Dynamic Fields Example